package logic;

import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Date;

import sql.Reportdb;

public class Report {

	public ArrayList<String> reportsql(Date start,Date end,String status) throws SQLException
	{
		
		Reportdb r = new Reportdb();
		return r.getreport(start,end,status);
		
	}
	public ArrayList<String> getreportclosed(Date start,Date end) throws SQLException
	{
		
		Reportdb r = new Reportdb();
		return r.getreportclose(start,end);
		
	}
	public ArrayList<String> getreportopen(Date start,Date end) throws SQLException
	{
		
		Reportdb r = new Reportdb();
		return r.getreportopendb(start,end);
		
	}
	public ArrayList<String> reportsqlcust(Date start,Date end,String status) throws SQLException
	{
		
		Reportdb r = new Reportdb();
		return r.getreportcust(start,end,status);
		
	}
	public ArrayList<String> getreportclosedcust(Date start,Date end) throws SQLException
	{
		
		Reportdb r = new Reportdb();
		return r.getreportclosecust(start,end);
		
	}
	public ArrayList<String> getreportopencust(Date start,Date end) throws SQLException
	{
		
		Reportdb r = new Reportdb();
		return r.getreportopendbcust(start,end);
		
	}
}
